Custom Document - Insert Merge Fields:
Decedent Stats section
|
FIELD NAMES |
FIELD DEFINITIONS |
WHERE TO FIND IN MIS PROFESSIONAL |
|---|---|---|
|
Age |
The age of the decedent on the case in years Example: 85 |
Death Certificate Screen |
|
Age_Days |
The age of decedent including Days Example: 27 |
Death Certificate Screen |
|
Age_Months |
The age of decedent including Months Example: 7 |
Death Certificate Screen |
|
AgeDays |
The age of decedent including days, with the text "days" Example: 27 days |
Death Certificate Screen |
| AgeHours |
The age of decedent in hours on the case. Example: 3 |
Death Certificate Screen |
| AgeMinutes |
The age of the decedent in minutes on the case Example: 57 |
Death Certificate Screen |
|
AgeMonths |
The age of decedent in months, with text "months" Example: 4 months |
Death Certificate Screen |
|
AgeYears |
The age of decedent, with text "years" Example: 85 years |
Death Certificate Screen |
|
Birth_Date |
The birth date of the decedent on the case Example: May 21, 1929 |
First Call Screen |
| Birth_Date_MMDDYY |
The birth date of the decedent on the case. Example: 05/21/29 |
First Call Screen |
| Birth_Date_MMDDYYYY |
The birth date of the decedent on the case. Example: 05/21/1929 |
First Call Screen |
|
Birth_Date_Search |
The birth date of the decedent on the case. Example: 5/21/1929 4:00:00 AM |
First Call Screen |
| Birth_Day |
Day of the week, decedent was born Example: Tuesday |
First Call Screen |
|
Birth_Place |
The birth place of the decedent on the case. Example: Boulder, Colorado |
First Call Screen |
| BirthPlaceCountry |
The Country abbreviation the decedent was born Example: USA |
First Call Screen |
| BirthPlaceCountryDescr |
City of the Full Country name the decedent was born Example: United States of America |
First Call Screen |
| BirthPlaceCounty |
The County of the City where the decedent was born Example: Boulder |
First Call screen |
|
Business |
The Business/Industry where the decedent worked Example: NASA |
Death Certificate Screen |
|
DateOfBirth |
The date of birth of decedent on the case. Example: May 21, 1929 |
First Call Screen |
| DateOfDeath |
The Day and Date of death of the decedent Example: Monday January 18, 2016 |
First Call Screen |
|
Death_Date |
The death date of the decedent Example: January 18, 2016 |
First Call Screen |
| Death_Date_MMDDYY |
The death date of the decedent Example: 01/18/16 |
First Call Screen |
| Death_Date_MMDDYYYY |
The death date of the decedent Example: 01/18/2016 |
First Call Screen |
|
Death_Date_Search |
The death Date and Time of the decedent Example: 1/18/2016 12:00:00 AM |
First Call Screen |
| Death_Day |
Day of the week the of the decedent's death Example: Monday |
First Call Screen |
|
Death_Time |
The time of death of the decedent on the case. Example: 12:00:00 AM |
First Call Screen |
|
Deceaseds_FullSuffixName |
The full suffix name of deceased on the case. Example: Jeanne R Malory III |
Name Maintenance Screen for the Decedent |
|
DeceasedsName |
The full name of deceased on the case. Example: Mrs. Jeanne R Malory III |
Name Maintenance Screen for the Decedent |
|
Decedent_Address |
The street address of the decedent on the case. Example: 234 Elm St |
Name Maintenance Screen for the Decedent |
|
Decedent_Alias |
The alias of the decedent on the case |
Death Certificate Screen |
|
Decedent_City |
The city of the decedent on the case. Example: Manchester |
Name Maintenance Screen for the Decedent |
| Decedent_Different_Mail_Addr | If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip is populated this flag is set as 1. The value can be same as primary address. | Name Maintenance Screen for the Decedent |
| Decedent_E_Mail |
The email address of the decedent on the case. Example: [email protected] |
Name Maintenance Screen for the Decedent |
| Decedent_First_Name |
The first name of the decedent on the case. Example: Jeanne |
Name Maintenance Screen for the Decedent |
| Decedent_Full_Name |
The full name of the decedent on the case. Example: Mrs. Jeanne R Malory III |
Name Maintenance Screen for the Decedent |
| Decedent_FullSuffixName |
The name decedent on the case without the prefix. Example: Jeanne R Malory III |
Name Maintenance Screen for the Decedent |
| Decedent_Gender |
The gender of the decedent on the case. Example: Female |
Name Maintenance Screen for the Decedent |
| Decedent_Identifies_As_Gender |
The gender of the decedent. This data is derived from the "Identifies as Gender" field, which is displayed when the Death Certificate State is set to Pennsylvania |
Death Certificate Screen when Death Certificate State is set to Pennsylvania |
| Decedent_Last_First_Middle |
The sorted name of the decedent on the case Example: Malory, Jeanne, R, Mrs., III |
Name Maintenance Screen for the Decedent |
| Decedent_Last_Name |
The last name of the decedent on the case Example: Malory |
Name Maintenance Screen for the Decedent |
| Decedent_Maiden_Name |
The maiden name of the decedent on the case Example: Smith |
Name Maintenance Screen for the Decedent |
| Decedent_Middle_Name |
The middle name of the decedent on the case Example: R |
Name Maintenance Screen for the Decedent |
| Decedent_Phone |
The primary phone number of the decedent on the case Example: (555) 123-1234 |
Name Maintenance Screen for the Decedent |
| Decedent_Prefix |
The prefix part of the name of the decedent on the case Example: Mrs. |
Name Maintenance Screen for the Decedent |
|
Decedent_Race |
The race of the decedent on the case Example: Caucasian |
Name Maintenance Screen for the Decedent |
|
Decedent_State |
The state of the decedent on the case Example: New Hampshire |
Name Maintenance Screen for the Decedent |
|
Decedent_State_CD |
The state of the decedent on the case Example: NH |
Name Maintenance Screen for the Decedent |
| Decedent_Suffix |
The name suffix of the decedent on the case Example: Jr. |
Name Maintenance Screen for the Decedent |
|
Decedent_Zip |
The zip code of the decedent on the case Example: 03111 |
Name Maintenance Screen for the Decedent |
|
DecedentSSN |
The decedent’s social security number Example: 123456789 |
Name Maintenance Screen for the Decedent |
|
DecedentSSN_Parsed |
The decedent social security number with hyphens Example: 123-45-6789 |
Name Maintenance Screen for the Decedent |
| He_She_Upper | He or She (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
| His_Her_Upper | His or Her (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
| Him_Her_Upper | Him or Her (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
| He_She_Lower | He or She (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
| His_Her_Lower | His or Her (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
| Him_Her_Lower | Him or Her (for the decedent depending on gender) | Name Maintenance Screen for the Decedent |
|
Interests |
Specifies the interest of decedent Example: Women of St. Mary |
Personal Information Screen |
| Mailing_Zip |
Zip Code of the decedent's Mailing Address Example: 03101 |
Name Maintenance Screen for the Decedent |
| MailingCity |
City of the decedent's Mailing Address Example: Manchester |
Name Maintenance Screen for the Decedent |
| MailingState |
State of the decedent's Mailing Address Example: NH |
Name Maintenance Screen for the Decedent |
| MailingStateDescr |
Full State name of the decedent's Mailing Address Example: New Hampshire |
Name Maintenance Screen for the Decedent |
| MailingStreetAddress |
Street Address of the decedent's Mailing Address Example: PO Box 123 |
Name Maintenance Screen for the Decedent |
|
MartialStatus |
The marital status of the decedent on the case Example: Married |
Death Certificate Screen |
|
Occupation |
The occupation of the decedent on the case Example: Engineer |
Death Certificate Screen |
|
Occupation_Years |
The number of years in occupation of the decedent on the case Example: 25 years |
Death Certificate Screen |
|
PlaceOfBirth |
The place of birth of decedent on the case Example: Boulder, Colorado |
First Call Screen |
|
PlaceOfDeath |
The location of death of the decedent on the case Example: Elliot Hospital |
Death Certificate Screen |
| PlaceOfWorship |
The location were decedent attended a Church/Synagogue Example: St. Antonio Cathedral |
Personal Information Screen |
| Religion |
The religion of decedent on the case Example: Catholic |
Personal Information Screen |
|
ResidenceFullAddress |
The address of residence of decedent on the case Example: 234 Elms St Manchester, NH 03111 |
Death Certificate Screen |